﻿CREATE PROCEDURE [dbo].[Designation_Select]
@DesignationID uniqueidentifier
AS
BEGIN

SELECT [DesignationID]
, [CreatedDate]
, [CreatedBy]
, [ModifiedDate]
, [ModifiedBy]
, [Deleted]
, [Description]
, [SystemDescription]
FROM [dbo].[Designation] (NoLock)
WHERE [Deleted] = 0
AND [DesignationID] = @DesignationID


END
